Table Event

Table Event: This video contains how can user create an event for table in OPNBI.

tip

Only users with Dashboard privilege have access to this section!

Read 5 minutes tutorial here.

• To Create a apply an Event to a table follow the steps below:

1. Create a new dashboard and give name Summary of the dashboard.

2. The Edit menu box appears as you click on Table Widget icon. And a widget gets added in content place automatically in dashboard.

3. Enter Following details in General Property.

• Dataset: sales.ds
• Select all the field in Dataset Columns.

4. Fill above details as shown in figure below:

5. Go to advance tab and drag and drop Country and Product line column in row.

6. Click on save and exit to save the changes.

7. Create a filter and give named country as shown in figure below:

8. Click on setting icon of the filter and fill the details in filter Widget:

• Source: Dataset
• Dataset: Sales.Ds
• Column Name: country

9. Fill above details, As shown in figure below:

10. Click on Link Filter and Widgets Option and enter the details as below:

• Layer: Layer1
• Tabs: Tab 1
• Widget: Table Widget 1

11. Fill above details, As shown in figure below:

12. Click on Filter view property and click on + icon of the country.

13. Click on Save and Exit.

14. Fill above widgets, as shown in figure below:

15. Create a New Dashboard and give name Detailed of the dashboard.

16. The Edit menu box appears as you click on Pie chart. And a widget gets added in content place automatically in dashboard.

17. Enter Following details in Chart Property.

• Dataset: sales.ds

• Category Axis: country

• Value Column: Order Number

• Aggregation: Sum

• Select all the field in Dataset Columns.

• Fill above details as shown in figure below:

18. Click on Preview and Save and Exit.

19. Add one table widget in the Detail dashboard.

20. The Edit menu box appears as you click on Table Widget icon. And a widget gets added in content place automatically in dashboard.

21. Enter Following details in General Property.

• Dataset: sales.ds
• Select all the field in Dataset Columns.

22. Fill above details as shown in figure below:

23. Add two filter country and productline in the dashboard, As shown in figure below:

24. Click on setting icon of the country filter.

25. Enter the following details in Filter widget.

• Source: Dataset
• Dataset: sales
• Column Name: country

26. Fill above details, As shown in figure below:

27. Click on Link filter and widget option.

28. Enter the following details in Filter widget.

• Layer: Layer1
• Tab: Tab1
• Widget: Chart Widget, Table widget
• Both widget link with country column.

29. Click on setting icon of the productline filter.

30. Enter the following details in Filter widget.

• Source: Dataset
• Dataset: sales
• Column Name: productline

31. Click on Link filter and widget option.

32. Enter the following details in Filter widget.

• Layer: Layer1
• Tab: Tab1
• Widget: Chart Widget, Table widget
• Both widget link with productline column.

33. Click on Filter view property and click on + icon of the country & productline.

34. Click on Save and Exit.

35. Fill above widgets, As shown in figure below:

36. Click on embed icon of the detailed dashboard and copy the external embed link.

37. Now, go to the summary Dashboard.

38. Edit Table widget and go to event section and write below script:

:::tip

**var tab = new CustomEvent("OPNBI-get-Filter",{ "detail": ""});  

window.parent.dispatchEvent(tab);  

setTimeout(function(){ 

console.log(event); 

var filters =JSON.parse(sessionStorage.getItem('OPNBIFilters')); 

console.log(filters[0].modelName); 

var country=filters[0].modelName; 

var productline=event.event.key;**

:::

39. Click on save and exit button to save changes.

40. Go to preview and apply country filter on table.

41. Click on any product line. Let's say click on Trains. As soon as you click on Trains, it will open detail dashboard in new tab and data of detail tab is filtered by product line clicked and filter value.